SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401319 LIMIT 1 [ RunTime:0.001737s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401319 [ RunTime:0.001095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809850,376261,609393,154427,469931,441792,1045977,424154,706838,679566,430903,58453,704466,229922,301028,751960,1044810,126226,309019,665883,961635,961591,748758,216730,755060,479871,326103,957051,62312,348348,560709,474089,54121,933218,902034,188252,43930,534399,724268,938445,285255,640427,799098,762538,788597,603958,825625,994286,534283,577707,427341,108538,415517,233297,876978,64088,937574,881151,832060,781086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002179s ]