SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417747 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417747 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683106,236879,866576,111063,409855,562349,913710,1011658,324318,100131,124104,960720,936983,309784,1020380,432916,906818,908160,714769,933995,403053,1025090,104111,824148,357804,327048,787768,156441,885826,234872,986540,1040828,46056,316851,469758,279950,630644,882787,991895,304111,777053,567395,806243,422591,792731,851246,391811,522038,22642,835645,344010,926774,932096,611894,479295,884929,969912,197103,506709,13640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417747 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417747 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]