SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19800 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19800 [ RunTime:0.003840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478254,351779,652876,1037438,176233,290128,191226,115632,356928,1024212,46149,98081,810041,48132,847265,563467,438921,982814,758225,498918,548918,560053,1035550,444747,355943,318811,861990,745120,566930,530687,175128,331403,81226,22045,198356,359337,328932,50232,397219,701620,299210,752192,1035023,664775,145288,970923,971999,240688,1014084,744940,442338,870132,229402,713669,82408,81309,1034060,556518,905487,347419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000860s ]