SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485241 LIMIT 1 [ RunTime:0.001022s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485241 [ RunTime:0.004036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698186,908863,527719,487837,1045453,556056,305653,627718,1038789,441319,380970,66924,549534,381223,620039,18016,89326,911380,525612,750820,212424,330453,357622,205453,314739,876863,956286,961663,642909,34589,472041,137522,334857,395293,388718,723571,355482,500569,356528,612352,984847,282883,760654,497670,459460,985917,989561,56365,224106,165251,428769,211586,886401,601628,358753,141402,118727,655880,882270,456136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]