SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509274 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509274 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337177,604095,259322,101728,490015,238127,473772,325380,964444,206787,473238,971128,923814,126084,256997,980255,160443,224244,776102,433031,853375,40292,545108,761936,1021148,185508,611237,810354,816676,920225,470515,209716,541309,483246,908998,312747,793668,52204,634178,484453,983031,229873,815034,856980,929714,363283,649446,312011,707492,353077,256314,295128,1007925,344677,54239,175973,948217,429091,478,935363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001815s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]