SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 676207 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 676207 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408470,825351,507865,82916,1029144,315200,115569,824481,54509,127085,314549,1043802,837801,142426,966089,107629,805995,952756,937035,14767,851034,255727,145888,303265,390356,265540,813315,1018151,357751,694379,13938,8155,865703,969228,345832,473805,964305,435557,820060,202571,1044064,784665,576435,765157,28720,735739,622556,764470,628450,200853,1017915,902390,878520,211769,280236,393991,710835,234890,93207,518518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 676207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 676207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]