SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450085 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450085 [ RunTime:0.003004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734312,348168,985376,212710,227390,374943,544159,199932,1036050,454231,598944,298090,973226,47615,395923,826581,30194,844875,1029627,876543,977937,361191,408361,679151,280006,691679,40828,742218,494745,852856,991951,335822,904789,364012,922557,715971,253659,974258,961347,420523,770160,55152,445020,1016376,212669,367999,536117,783119,1032318,718161,283917,188015,28624,790186,27944,627745,340266,918944,523671,621554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]