SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 649816 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 649816 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934928,499357,1024902,444267,402290,924300,413359,406530,781281,135670,1022884,1003096,1025504,239178,540942,708650,742595,131185,723780,60283,412462,60949,514459,22554,748242,29072,10320,361687,599597,848864,77331,240969,671339,520598,898442,507429,782564,92599,83504,376404,886488,965564,813541,279343,402368,320521,225136,270444,13076,990928,265483,884072,487161,434223,827641,163549,265377,239770,536011,485596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 649816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 649816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]