SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413616 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413616 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823240,233752,417692,685360,119852,751274,599070,866556,1020861,613494,942206,648911,13903,1043979,1045067,279346,855146,204611,954589,172904,649550,230389,20924,535157,840073,102108,874819,837011,745651,539340,880057,177875,800254,878711,209419,889386,589264,34582,276411,535720,293904,697906,129840,256992,197049,827456,41919,253613,113272,985556,817527,631065,613644,506373,351155,70187,614589,246633,720630,903949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]