SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44056 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44056 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466224,783117,485187,754466,888360,752974,956501,268312,952655,440131,123416,681276,367414,147487,878145,791393,667763,606219,72844,425343,909269,399107,99901,367138,476613,718921,532555,285925,599417,250240,951333,951566,620643,565654,284179,317235,144872,261598,384979,4391,1016683,769126,411622,705734,503958,128295,194350,660377,56430,356998,539342,389272,336300,34212,1015231,526204,167791,641440,74937,878719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]