SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543086 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543086 [ RunTime:0.002727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380480,447931,237017,413009,407906,338407,123697,1035296,681881,574298,563175,361145,643744,1033725,730093,859574,615840,852310,629402,66963,781414,509571,402102,649771,155418,583914,869828,1012614,759719,621380,50645,179483,314370,58807,1009821,510137,218970,848282,409387,565594,254879,648350,246454,348905,737762,258680,590411,232114,478260,707393,228624,827221,10859,633059,625253,538584,210307,238678,498482,710326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]