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` = 567033 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567033 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765341,745845,786344,238354,502658,1042952,582978,44348,700493,661175,1043967,744885,510800,801800,297476,87801,963497,1024619,366566,68990,567480,426662,874966,146444,649086,897653,645894,279670,147645,861714,36165,907547,370030,629703,655795,1032343,209499,238178,848356,785813,765691,277727,628160,703847,79382,198276,606532,345205,151752,617181,892639,963078,481995,165939,626989,243623,246012,242705,153951,279323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]