SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512626 LIMIT 1 [ RunTime:0.000730s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512626 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49362,471779,175260,898366,379338,329290,438714,920766,541635,301981,465561,658626,623521,65687,657092,999080,681063,909647,300729,692288,5781,855992,394742,673848,926752,122078,493009,285900,396101,559344,87817,136354,137894,974742,251931,210426,697902,954391,703196,499195,856829,1015095,54184,498603,52378,751781,671416,315577,772366,531473,1003787,1016877,444808,149135,129308,106395,210085,146481,591707,278876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002444s ]