SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447605 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447605 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4110,362610,406377,534813,10341,481711,25875,366012,9984,6473,66245,228836,644842,764111,335263,318359,834175,726790,448342,376667,118303,175124,303032,138551,26912,873141,113812,7046,504014,22812,258643,678100,448706,1048289,369852,933525,133054,988044,286764,444191,400160,239365,386009,6689,436182,339641,476027,220406,1037948,789203,765005,506984,335176,207356,731497,212174,979796,23850,741114,934778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]