SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310051 LIMIT 1 [ RunTime:0.000563s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310051 [ RunTime:0.002365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149641,570783,830543,538106,462911,153231,253879,263122,696124,140939,519089,395139,370309,377602,410755,950498,105804,236385,86351,776514,809912,1027299,775682,498912,1021285,719643,767508,163872,26334,215383,1026330,625412,926664,780998,711397,772644,796925,204812,284762,163876,84591,847503,420850,943924,918305,548361,95068,86802,45009,185454,129102,1022258,799928,570301,66128,78485,823517,471178,200188,91998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004524s ]