SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974491 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974491 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44758,537464,37690,998139,759423,462014,269407,301419,769871,236284,992980,236080,554435,928949,1016242,66964,906444,1043848,102533,937999,583409,399878,195225,652385,6182,395507,296232,683756,469208,432112,201716,420508,271599,140632,677650,79577,485127,680039,793378,167487,428093,580804,94311,407211,1005592,3397,520651,885157,1027420,987243,950709,246612,874391,113986,392126,892251,858850,152681,773648,726271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000914s ]