SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003895s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501579 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501579 [ RunTime:0.008058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1275,521543,254111,886170,930366,591176,392972,419365,743518,441505,534524,947440,740067,541247,528559,232234,505713,340686,183222,526257,948097,948856,476598,819108,732994,1040911,469175,359521,773089,732403,955444,570759,505965,746997,361223,754304,322516,352842,761966,1008623,160689,313160,405806,483743,685145,110350,103995,728579,23836,764813,502549,976455,774833,964398,114536,114511,104685,95991,36738,320728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501579 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501579 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]