SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502850 LIMIT 1 [ RunTime:0.002496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502850 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529023,855166,420827,934611,447508,534584,238224,376490,448867,677287,515238,440371,685308,173015,489085,38286,16202,626871,875948,123132,560934,1023406,286905,40420,346121,213853,76359,802498,176823,992741,806080,55642,36339,404528,807255,516881,357125,304234,6614,368082,759883,153834,652584,1042553,441598,603004,828045,31314,381548,374912,466051,226267,423731,976223,1025051,451295,539692,692749,785140,819819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001633s ]