SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411306 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411306 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040036,308547,199234,811362,16354,759115,435683,145298,284668,406918,206947,203104,922825,957376,917131,392667,102615,830873,1044826,157035,355267,558579,996091,635344,134544,490499,876529,482233,489754,967527,760635,877002,892109,100339,497520,849508,863756,411086,508560,816501,478304,485210,325542,978009,405244,28299,586685,390635,239230,815340,331770,571595,145312,709184,211505,75559,167995,806343,344979,419049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]