SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022928 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022928 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404243,541135,734723,684942,986183,46280,327949,773969,325307,593682,882850,542183,405655,503580,426942,736936,219370,111233,800301,754062,89859,780067,565727,658253,814257,386599,183232,714807,887194,968355,264524,288903,925119,91534,416777,183644,884882,441182,822379,453558,319002,623184,471608,956625,762359,666731,481839,662964,998195,178050,517820,918543,804336,505455,153672,357610,979851,31060,176734,96804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]