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` = 101588 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101588 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412395,698850,400992,200436,920475,55952,764612,12586,1028658,910304,48831,500384,444762,533704,356200,533457,1023617,230281,979916,206252,609902,75616,34119,124710,689876,1036428,512008,220200,973344,423803,361725,245931,347867,676838,555857,1006739,843039,857120,977958,942278,920769,739243,894090,940513,667105,275491,586214,953632,216785,129092,338654,29939,203307,120973,226484,865392,608180,387417,933505,335319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001213s ]