SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412671 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412671 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331063,413069,852998,883939,942245,686088,708419,598119,266891,137838,731416,435317,85863,758891,512121,946452,672257,571158,658394,966633,350398,112443,1020697,46853,417911,348178,18680,801445,508343,466747,996357,234462,711742,950532,207899,1008257,698281,61198,520947,722914,961193,412780,246794,559307,351933,62669,25984,784791,778269,700539,89852,639198,367613,633950,71366,606992,597546,914799,936250,819225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]