SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 259876 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 259876 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334943,169074,1000698,1029739,608378,136286,1014967,930709,402653,975940,291644,978075,398407,440459,956590,677221,309174,124856,31011,739327,401548,645037,763126,604459,15536,869527,1015234,483489,243317,655900,976046,1011794,407149,415491,684352,590034,1034245,931512,700369,996492,296552,773999,86156,628264,229142,853582,301653,536909,21016,474434,589711,990975,96173,367254,104385,701177,718071,747829,900208,363819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 259876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 259876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]