SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267212 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267212 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66195,773826,333592,708688,895987,912406,877580,791656,194240,953272,606499,424308,341759,249659,661267,110366,502123,393624,242422,794589,200118,532241,702235,674617,808154,309220,743206,498987,731136,768124,426790,508028,801035,1029059,967170,870175,922870,764369,753486,622942,23152,743098,820732,266613,267736,190320,825423,158351,903690,702812,833082,746794,405018,994612,141173,378006,170177,122314,1039047,587561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]