SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040700 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040700 [ RunTime:0.003433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573556,385587,160220,984301,271994,957608,288319,984449,1008089,69698,297916,553658,420267,253989,22706,1007562,105271,114629,561770,976666,385847,399712,5111,631349,8702,812020,472053,203132,961759,515346,387716,969055,472560,502475,928726,229003,543194,902707,98960,44361,1011948,874083,494047,258508,619439,201459,214386,116029,119099,913000,347073,81020,147825,984586,17093,167650,561033,582166,522280,295708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000751s ]