SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513739 LIMIT 1 [ RunTime:0.004807s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513739 [ RunTime:0.004745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918790,11044,876794,776834,240515,237322,607170,886213,584129,488838,380424,1015724,288819,284673,873319,180709,178718,583241,428623,665140,87942,289623,3474,40538,924288,156809,501448,954351,952830,602235,1015128,478975,34575,857956,737277,850876,938186,329786,979489,93049,828119,89182,202074,533720,297089,924332,989016,518012,136897,40473,788658,742851,545171,12752,720934,390544,799617,87116,780363,292128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]