SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001717s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405582 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405582 [ RunTime:0.002847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52039,258236,589429,875626,378688,1041475,555172,980199,946800,676973,223847,250960,595286,1047881,785241,837810,720627,223488,923376,384193,251859,120498,146377,20264,519359,695281,388641,238305,631234,23372,745660,992742,50523,902622,130111,471491,517486,432697,903987,117855,451377,590355,18945,515963,606399,837490,546080,794459,123844,593024,444165,650028,223781,926148,508006,172693,74528,399465,349757,787576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]