SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456819 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456819 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555812,903931,652367,724559,21026,483565,647066,34167,680693,821259,411983,690648,951771,917911,525441,278098,413457,454691,660660,46636,512185,303582,219695,24347,649553,673011,577368,820743,158249,232605,176285,124564,602219,451624,850297,836371,229763,22098,785711,438276,972629,555064,840749,627016,964771,60241,920752,100501,318204,711721,494054,1032524,419791,397788,28283,690277,18524,136169,950130,816719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]