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` = 1017506 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017506 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939700,464566,393906,607553,165472,283139,179386,330620,695274,680076,376254,856681,505821,776262,443100,823700,132902,1038903,631390,67543,543036,455547,339397,669979,264725,1018620,7166,958047,6544,847962,956289,735685,306280,109124,107782,669620,292858,631843,536251,151298,727769,1007145,613777,923766,1035765,354831,890559,491595,425873,499453,555598,901761,1008770,118003,1048246,783212,96640,813483,383576,339597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]