SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416489 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416489 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498819,235835,906496,847397,147342,996999,4596,85979,614290,108009,662778,659694,327816,524410,442508,455863,620069,215131,343382,376153,346449,810430,47417,465349,287977,1029519,88044,153958,1042901,695960,592656,105012,322351,392837,895973,643331,128518,324384,365525,1006066,403657,956517,317566,284608,8805,365788,160028,994253,1017149,909459,599089,430889,248611,544671,361457,440924,328850,906735,744319,773351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]