SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037916 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037916 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525998,1027462,20397,758936,510527,385252,1004348,25867,988450,926835,199710,1048603,217925,606293,439740,452797,315020,834011,257170,743500,218653,509037,596554,943536,920177,52342,436723,216953,900729,674090,393695,458909,665455,426064,333110,146091,743072,803912,708894,897188,401615,179990,99934,982680,866920,899364,721968,948464,930232,841545,1035248,680973,972366,97851,1041973,206067,131017,670432,163603,419548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]