SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415354 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415354 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557091,662728,399226,765890,401495,163678,630318,84508,432288,37208,887597,739455,391214,645867,774131,269062,529592,51031,282654,216476,305367,343158,572052,896441,167322,276595,692180,733882,782143,500589,884202,70369,682129,1024900,228202,553596,316554,76300,277887,322309,491194,892431,756648,877061,219679,264069,988483,442062,199168,81527,215326,106002,868634,546687,546260,21650,216716,47281,538398,116699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000913s ]