SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196963 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196963 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013848,454186,369299,80838,418423,825597,201379,317008,281823,711054,579689,532953,4725,408904,328639,939076,185681,553593,336595,326847,835840,64830,938571,787689,922514,941040,403733,199132,73463,10341,364826,586888,262286,468035,216402,364556,503449,293425,217285,882410,30552,937721,694048,411317,281449,567583,89238,723367,391709,804246,97683,840071,1040350,921617,302493,446363,104002,343753,613228,681348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]