SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509181 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509181 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221191,504028,3622,987006,48905,748240,744497,725316,598496,225812,805176,575053,90873,783200,359133,438063,1046054,711436,562845,424745,758695,436702,604721,564332,815853,316007,497001,121089,321129,675004,738562,985784,904937,288363,17061,740294,528152,296129,188263,115845,1011425,741166,438239,670066,1008720,764844,444679,931834,630420,758274,45716,759114,234264,148555,217001,355576,995259,278944,992134,1022012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]