SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047972 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047972 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58083,833544,786288,599054,706359,564313,522831,162669,398356,828002,392904,647933,65984,197523,402508,196675,469285,157010,187483,229280,710375,920882,532371,652762,366642,552167,498580,104733,142570,716424,999663,980628,756479,683127,864033,821014,809873,312307,442006,785687,287736,709700,1031958,1029128,425884,793127,258903,836900,419432,130847,909423,626729,854030,24695,603217,519648,409719,622101,210582,432624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003249s ]