SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583104 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583104 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904204,138679,1043161,304890,563715,380746,422726,110843,417134,282447,871477,806302,773753,563479,289190,915803,801057,73789,830315,992721,331562,402356,447290,327818,879940,2827,907661,539817,145204,695328,492647,693665,401105,436681,447298,367332,806632,756032,296841,771643,89734,837179,16490,629128,228334,744137,502263,634186,693988,191229,385101,42949,1046455,907478,959666,459855,945420,340920,803280,418508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]