SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040009 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040009 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791757,48601,691792,46562,610865,436674,421238,340130,502467,975174,233266,273946,504933,895730,197988,457252,450920,94883,831365,105975,1031211,764557,973751,385577,699760,986284,486864,455563,417783,765811,684346,489540,917898,728924,105648,849012,126557,60960,760663,465041,1046089,263692,299049,175740,171534,455659,707313,942852,55784,39110,465850,1130,533616,673147,250649,776922,998583,718601,997214,312156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000991s ]