SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193469 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193469 [ RunTime:0.003401s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580146,40828,467299,954196,111373,564088,754859,979599,1028328,479920,563268,906532,695171,908322,401197,368528,605447,999453,857861,424663,783002,124279,49519,69400,858880,539613,953984,1024555,830244,552177,607690,382715,30349,65124,16042,365209,722644,937680,885039,471757,587428,48041,151506,480970,660448,389248,921910,25484,834928,943760,118501,806200,72467,32049,654425,752734,772087,782359,1015518,1031142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193469 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193469 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]