SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442922 LIMIT 1 [ RunTime:0.001193s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442922 [ RunTime:0.004116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497341,497652,324216,394575,402440,93501,537777,977261,537718,199688,456718,797604,521245,639524,236353,337389,942215,685078,108810,280479,355739,367057,307788,52239,688189,328049,424918,417721,504332,938503,939577,814486,494827,275854,624474,33550,358238,685034,135144,235562,441927,271039,690313,547511,693055,309220,461851,14700,302107,420669,390444,222238,410372,171602,586936,201171,619100,238521,915975,693303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]