SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022463 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022463 [ RunTime:0.004244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46606,62545,644920,1015295,659844,239468,130528,571970,472053,507218,653015,1043104,484941,606585,487185,943886,983609,429960,381236,888783,35433,881448,926888,466968,856715,638914,258057,859909,437716,773959,768192,818049,16151,974692,977785,218330,866599,685070,502721,274436,38610,489758,875291,424570,1023719,465605,61339,588407,619950,28749,749874,1009666,29760,487825,373300,571185,1023602,512153,881356,62686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]