SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428562 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428562 [ RunTime:0.002819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226874,364458,976761,921792,216343,522371,283676,342304,226,42923,601896,871708,233094,685246,716764,744159,89303,438509,825971,474823,325200,942736,291027,672667,137784,196872,32155,316726,607405,720065,610830,603670,936110,941740,108552,712864,309636,276950,326551,176226,635386,307161,223781,629651,79756,902927,849603,453,337712,155693,1031993,401397,696444,411858,20042,792239,947833,583688,566600,453132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428562 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428562 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]