SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044280 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044280 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156556,158761,230148,779032,276589,63099,897811,28242,436040,14731,857811,448672,223035,906930,240952,438894,135020,945813,158038,18866,64540,72312,700461,30122,153973,129328,78980,207394,666547,375788,467401,72532,1039210,682175,287381,499206,811953,817453,644288,165843,892562,624052,563027,280486,92264,542097,8691,491812,980134,654196,947819,609046,415024,527751,480628,816511,72817,998243,595534,689870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]