SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107470 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107470 [ RunTime:0.002769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500497,405628,820232,925228,502935,561193,796395,628739,136009,371338,1031234,807978,683501,910892,466381,361050,177963,497024,185172,666551,674512,592994,773227,448683,40130,83912,273359,276459,683378,531585,959351,209442,563162,110286,138496,929124,326547,799447,705731,642219,903942,811511,167997,262617,1027019,440690,16275,991884,155148,420250,159066,853387,716931,855329,19849,267816,119869,66670,444746,10104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001857s ]