SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505126 LIMIT 1 [ RunTime:0.000744s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505126 [ RunTime:0.003242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742916,290737,275349,974797,129489,60902,188100,822726,270195,841015,273620,982500,748574,697837,446146,414249,355276,345010,523394,209885,652975,269839,630007,867035,735209,616549,945263,634007,749305,413935,961260,211796,995466,331791,393816,892915,594294,68908,251798,400267,857911,201436,479209,336724,98677,125888,237809,264597,915967,632023,410946,262509,782041,334250,774356,329844,251341,600093,697854,55491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]