SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014016 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014016 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714536,114373,640098,520705,437880,717243,80236,528564,456695,279934,737408,1014559,310787,777955,637995,962426,613383,91223,1000869,888968,900392,1036355,602544,265276,974671,698836,987785,52012,359909,906377,991726,270588,871261,425670,664671,946633,377528,799693,382928,312980,901661,378040,1007750,248546,901840,176541,487276,609292,354159,100512,286970,612028,115388,556439,914624,624745,182268,226077,473885,644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]