SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550318 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550318 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408406,49414,504837,123274,17300,475575,452942,1013674,690124,877078,844088,332932,886853,575806,559231,525336,775556,180451,292099,185409,99120,374173,848977,760077,894897,133748,917819,439301,117332,180099,60278,926209,258028,860498,696809,114634,980459,772275,572483,669628,431233,506216,946819,206562,837325,795329,961439,917821,778838,128291,644799,840052,190035,749790,19690,185285,424428,78351,987224,9559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]