SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334320 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334320 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901027,556967,200320,45168,984860,628306,607854,107996,1023496,547331,436703,570897,279866,447320,310586,1048026,483645,52435,12765,66006,97601,129077,724843,868308,120546,556315,1026462,290198,972377,524043,162615,104045,490708,189430,977934,357964,204461,115528,1009212,701294,339491,515295,236588,363788,53299,385907,736730,556316,867501,418272,216500,42307,1016412,425860,253279,523575,443978,314112,122248,507209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]