SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413420 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413420 [ RunTime:0.003165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508698,507609,787428,852407,863100,497590,117311,104403,660191,761066,786797,1035988,101087,241032,692876,729771,574000,452149,300978,560957,236930,860070,962279,86545,792695,651427,602734,404654,140250,344458,647600,829536,486961,864240,634675,706574,180168,68530,382000,973089,799394,727359,555089,668859,847580,1021929,766628,357859,744980,960379,219044,64623,170144,24463,380211,91461,773314,816034,780691,626851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]