SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 209160 LIMIT 1 [ RunTime:0.002124s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 209160 [ RunTime:0.005336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193733,653065,618027,528031,393787,368668,200531,997282,1027253,48719,1042406,264836,468552,1001506,609964,857936,417271,219584,136987,500012,378593,246674,1004063,669962,589515,895878,51154,357545,705441,157343,428115,351614,185757,1022507,370856,213284,862923,504222,781875,485385,853891,199121,948885,808793,520455,264280,876325,8044,765300,718715,503358,859728,1000681,803835,859772,595598,385086,1033109,179708,477783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 209160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 209160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002821s ]