SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52813 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52813 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116208,767313,749363,1016315,617589,777908,234345,674948,940073,399115,882085,442366,352681,851821,407522,495558,297721,476835,7386,467408,951898,440526,206847,693406,85416,775970,4619,757064,416186,29132,498609,1046263,640832,885177,798706,466435,951573,25367,390969,455245,132249,747034,699176,402385,503045,252958,69531,809715,408467,31581,455959,776100,122542,105219,886829,122151,440214,613843,76077,234888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]