SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012357 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012357 [ RunTime:0.001428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339050,121037,297448,415107,469482,492428,776402,354309,980492,823992,136973,394591,789337,560903,980957,85812,651581,226480,85897,592568,474015,930387,759183,649505,209657,241508,509305,110283,299304,506145,203048,82440,706451,158551,1038510,729140,808715,628862,740198,725301,519494,1017145,371391,72647,931263,360197,69870,774641,337880,29528,983628,1024292,656848,751971,395842,639121,860924,668868,135363,1009470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012357 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012357 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]