SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295083 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295083 [ RunTime:0.005328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391387,21682,311378,973807,587059,962205,324423,428440,859679,10197,700280,851109,251265,634152,368179,354194,1046,171789,297720,291475,830545,717635,257231,338080,1044200,134708,860795,537094,890784,175504,508737,44607,855332,274244,106729,863295,1004446,133272,918576,953495,29855,95007,169157,747773,434281,1040383,802747,1003740,1010348,190366,102253,580688,422586,704428,81398,481552,430203,1003665,997219,934885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002546s ]