SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001951s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480180 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480180 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739598,200725,483326,470639,401720,661361,357136,1031200,496100,969247,593924,685207,441121,903983,664159,345222,792366,181570,731775,706111,650670,31158,355476,574612,1029260,202646,651264,588446,771774,727075,533509,848420,484349,717960,886796,875099,514490,182850,848750,3568,95585,954408,168531,181336,918408,774725,941198,879985,271905,691831,733540,972391,900039,731300,539087,777582,831991,502998,245032,853141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]