SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342084 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342084 [ RunTime:0.002603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649940,102284,74705,928556,690201,39930,1017737,659185,52931,495105,832105,995695,91540,250308,37014,63698,497077,468227,343400,206195,641944,116869,144916,687758,85840,462556,902809,370277,843257,109078,522737,661280,455204,406850,887963,617453,781300,513744,841083,465064,295524,413059,935455,669994,961342,569993,141324,151606,1018589,420705,890741,106846,239770,672584,899974,983081,524188,146428,562157,354540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]