SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027860 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027860 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166636,276703,378467,114154,93959,945967,199741,227167,303136,563843,158378,785760,922585,515165,1019644,1002733,897313,736774,182345,556003,264965,309873,263984,785536,828653,897039,405905,1035543,617140,672695,82451,999507,726129,336267,980526,435637,560390,583,627360,567629,182056,512328,219976,48098,378560,126314,112311,909883,302521,862375,612376,116142,884411,841410,581538,836985,643334,449314,1000568,710040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]