SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200348 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200348 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658390,103861,195595,795203,110636,628188,1005360,84701,644779,596453,1001184,494219,501117,104318,329815,484918,579056,444743,275673,1037659,627449,274333,234108,853982,502840,730621,337526,939160,278366,162136,349548,387571,578757,1002286,946637,917196,724055,967290,608342,262682,830341,384458,392921,1021315,589482,836571,1021703,256205,697457,100862,572910,295161,857895,759342,55122,118733,362027,255976,211738,742941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]