SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542014 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542014 [ RunTime:0.001418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680540,503577,340698,167436,590840,870298,31920,993234,474464,141340,1032482,205859,967780,792448,873932,229046,416070,543717,930495,680475,64328,954401,634525,729393,404375,12723,982204,759398,770196,201827,391228,985645,308495,433371,6724,89609,434708,320853,433321,619487,477992,915912,275629,272041,926125,154547,586657,491325,1020558,249620,299419,1024164,18928,230484,458934,709611,220478,780542,970215,993679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]