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` = 407641 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407641 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254930,734267,454412,138898,355225,36235,427593,108318,1017022,761226,667289,977002,559453,868702,681041,905314,349502,109817,631580,59402,771803,85106,1034001,580813,47287,543638,117197,80473,253686,290373,1017403,956928,953276,600649,4499,746473,273933,530666,945954,145200,736986,852192,19309,693147,462467,638027,520453,961955,400990,96841,201898,886985,556480,899383,707339,308587,79520,1008418,62769,702582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]