SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512213 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512213 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316035,297856,537922,1018166,173416,949865,172070,762758,50573,625841,409050,92094,914869,865816,985270,602699,775494,167159,432741,611340,461567,815426,107241,1002842,449648,205427,523798,329046,235979,864256,138341,471758,614197,145407,31846,829134,1043869,913686,875585,423334,1021627,380296,360803,576897,628501,533141,547819,788141,508361,959490,167744,22333,495633,902239,362586,231170,108844,614078,499852,372373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]