SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458909 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458909 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325766,228605,899250,213596,864885,268413,394055,148387,996145,324394,861472,610960,902804,763883,421877,379650,312219,430551,701779,360585,598282,140779,569468,802639,452139,600734,950978,78311,387746,156675,242313,671717,1039733,113670,702015,799920,217074,266138,870851,953229,715114,34350,655987,119710,177083,480180,722940,356535,253623,1029465,991113,593420,670502,161012,656880,520281,146334,522385,997355,971742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001146s ]