SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449073 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449073 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247032,155844,733918,183233,262688,371,270778,890080,257184,675997,788869,519320,264326,553494,340222,825996,472871,1017033,691945,242442,287228,296723,1019406,689154,523273,778845,746649,622812,7683,133106,954778,236120,780691,449137,285486,606379,467773,349615,495484,238915,393840,378966,99872,484885,190438,885066,663382,19820,680075,682500,2148,445519,1015445,588528,651117,648379,407662,676483,264559,295039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]