SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681823 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681823 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661641,772298,903696,164079,714512,913245,648485,57024,262229,76616,278381,126453,237752,1027935,290511,789792,396944,98587,132431,262384,486253,689729,1005032,821122,1038087,299920,729670,29341,752673,108649,87546,261850,71789,401911,37606,790188,235317,78171,225813,1033020,325135,321610,890642,675377,47520,412898,441262,622914,745321,882112,14050,344287,369369,935319,728792,832389,357601,305298,970227,389032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]