SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42922 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42922 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550348,367317,515076,693136,84913,585472,980013,1046451,801609,828906,599866,906376,856323,65706,861888,1000565,389947,79673,47517,345066,770744,339149,277710,181204,880948,94699,259715,256303,708511,503548,726393,700983,434902,400548,15650,944691,67854,511040,551728,121497,206695,31485,467614,579943,984602,11924,717516,1009534,910327,119923,892213,330268,281061,1042832,501854,596144,884616,1001999,254694,982783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]