SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001807s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446612 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446612 [ RunTime:0.003219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465147,246236,43414,744199,851451,858716,507077,962620,492007,530789,54251,342187,273125,553547,153187,716104,685305,386686,544852,198577,496103,106912,256941,418480,462121,872712,50288,410644,189150,423343,769861,747509,93362,838860,988004,359500,805768,954278,59840,712552,720646,613473,905610,611642,257804,613771,169592,304824,460877,526930,703074,149262,723551,485522,444474,421700,635034,658040,236394,317696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]