SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421105 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421105 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162162,161376,262349,642101,265417,1006268,135116,771817,612046,573218,620440,606965,914495,520073,251468,601597,537659,229456,614215,328672,993193,916176,102412,650970,253821,815182,455892,69370,742946,260098,491259,623649,523916,41135,791651,360426,943617,710550,730686,153396,141043,555453,285010,220703,314869,493229,831932,404894,285221,773589,178668,567459,735619,402902,464963,657912,280109,652748,681019,403807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]